SUPPORT / SAMPLES & SAS NOTES
Problem Note 56736: "ORA-01747: invalid user.table.column, table.column, or column specification" might occur in SAS® Merchandise Allocation
 |  |  |  |
In SAS® Merchandise Allocation, the following exception might occur in the import log:
ORA-01747: invalid user.table.column, table.column, or column specification (p_flood_to_children (11,1,1,2,ATTR_M,,-1,-1,NULL), SQL#:7500
The exception might cause issues with Flood to Children functionality.
There is no workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Allocation | Microsoft Windows Server 2008 R2 | 3.5_M1 | 3.5_M1 | 9.4 TS1M2 | 9.4 TS1M2 |
| Microsoft Windows Server 2012 R2 Std | 3.5_M1 | 3.5_M1 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 3.5_M1 | 3.5_M1 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Linux for x64 | 3.5_M1 | 3.5_M1 | 9.4 TS1M2 | 9.4 TS1M2 | ||